UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NRq8hYRWbtBaLdkrfZEdZWWdtwCC78dllDlgNP/Jmcg='
WHERE
key_id = '4d0880220ae4e355430b9ea196f74b64d0d52bdce53d5c31897d361fb3d86b02'
AND (
token = 'NRq8hYRWbtBaLdkrfZEdZWWdtwCC78dllDlgNP/Jmcg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)