UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YmbfN4ulhDpmJfwAzXF/eFL0GzD8vRHXeOa0S+iKwrA='
WHERE
key_id = 'f17cff5415927ae320548b2e30283a2fa1f61b4e36390160c94b69fddbf190d6'
AND (
token = 'YmbfN4ulhDpmJfwAzXF/eFL0GzD8vRHXeOa0S+iKwrA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)