UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'swPgCBU14Sal84aT7pWb5mEDc/l5jV1LI58r2krkyco='
WHERE
key_id = 'd66ecd2e90badbab8427a06e7eeef80838f9a7d7be95b5aed46df1554c0067b8'
AND (
token = 'swPgCBU14Sal84aT7pWb5mEDc/l5jV1LI58r2krkyco='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)