UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gIzbC+8nuGcgxHQA2PvMmdGguQUVIdhAJXn8r6UOMBw='
WHERE
key_id = 'e20e4c360fc23cd58338f91b9e7ebb90c2927ab2d1f8b4a92b4851e4596692fb'
AND (
token = 'gIzbC+8nuGcgxHQA2PvMmdGguQUVIdhAJXn8r6UOMBw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)