UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XxhP4Au4UQFZN0hsGMpxBMxv/TGq/4yensiN9d0zQfE='
WHERE
key_id = '146cf4b799e34f4e315d44ecc9b0b1b717908980712024efe6877c18d1da879e'
AND (
token = 'XxhP4Au4UQFZN0hsGMpxBMxv/TGq/4yensiN9d0zQfE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)