UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JOEHCNDhCI7L/5gDCR8vJtZms6raSThaqvCWefbYXOc='
WHERE
key_id = 'f81929354b90bb46c200ad8f378ef06610994e266692742507a2afbb643992ea'
AND (
token = 'JOEHCNDhCI7L/5gDCR8vJtZms6raSThaqvCWefbYXOc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)