UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B/5aEE7nWq+z4tOcFTKTVF8rF2EXqDNAh3WfpETwAiQ='
WHERE
key_id = 'abacd891bd19ce20005c1e7adad291985e73befd375ca4125b431584c63e64f9'
AND (
token = 'B/5aEE7nWq+z4tOcFTKTVF8rF2EXqDNAh3WfpETwAiQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)