UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AfeWY4BrRGxM2jnkwDOCEuBo491zKVRm4TQ+BMeGvPw='
WHERE
key_id = 'aa8eb84c40ca1c3ea4d8ecc9107f5efe863912538d31d81577f24a0072ff428f'
AND (
token = 'AfeWY4BrRGxM2jnkwDOCEuBo491zKVRm4TQ+BMeGvPw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)