UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xdCcl/WPVtDJ17VzCfQSd7DZRYx+BUK6Id4C2RrOGog='
WHERE
key_id = '9b99a84181971bf1a74b36bb6d33782a3741a894f0adb3d09f2146b78f57df93'
AND (
token = 'xdCcl/WPVtDJ17VzCfQSd7DZRYx+BUK6Id4C2RrOGog='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)