UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LXp4i+CbnqDqLA5XuF6utDtE7raL63X1cuN1b5WIrdo='
WHERE
key_id = 'f0742443f96e71922241e09d5b4f8c77845a12dc533eea5defce61b3dcf0e5aa'
AND (
token = 'LXp4i+CbnqDqLA5XuF6utDtE7raL63X1cuN1b5WIrdo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)