UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zp2rlcMSdaywZhYUruTQK9w29gpl6pLj3iTjKGhOe6Y='
WHERE
key_id = 'e7afd2892e42b142fe77a87bc5f55014a5ad9b6fd3b60ee9b2738fa80ab95392'
AND (
token = 'zp2rlcMSdaywZhYUruTQK9w29gpl6pLj3iTjKGhOe6Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)