UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VopzXxKSHQA9eMORQRdhehHVYq5Go1v8uMgXPaY6CEk='
WHERE
key_id = '8a334247f646ec179f989f48e8dc6ee0baae64c16bddff0c5ac7e82ef1d927e5'
AND (
token = 'VopzXxKSHQA9eMORQRdhehHVYq5Go1v8uMgXPaY6CEk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)