UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'foGweBEkMaDyYQUvDffEf2P4QDxQT3o0j2szhLRIREU='
WHERE
key_id = '7eb527019fcee0e9ef485d3c010177e135e59b4e8fe201dd2ea9f652df3ef918'
AND (
token = 'foGweBEkMaDyYQUvDffEf2P4QDxQT3o0j2szhLRIREU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)