UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZhVRshd7SmIWXPXnxPsk9WVKrDu9Nr6F2tX+aFZbM0s='
WHERE
key_id = 'c0f27a5dc3846cdf7e08b1a750be9b3f9f00eb353f309a61c065fe5017fe2d30'
AND (
token = 'ZhVRshd7SmIWXPXnxPsk9WVKrDu9Nr6F2tX+aFZbM0s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)