UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kR6YF4ooeR6k/8xKWcr8eqreFXuUBrQbuYez/lJ+HIc='
WHERE
key_id = '7821d7761488da6e1a54ad245c3a194311054c1b2aec647c7f670a748b09b712'
AND (
token = 'kR6YF4ooeR6k/8xKWcr8eqreFXuUBrQbuYez/lJ+HIc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)