UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DPfXuXYO7cSbyBWg4JUN9U6QcN4DSU/C53vjQ1T1OW8='
WHERE
key_id = '6e1ba03110b221dfcc0d6e4d22afe7b14a78831e155c50a334e30d957341f7ab'
AND (
token = 'DPfXuXYO7cSbyBWg4JUN9U6QcN4DSU/C53vjQ1T1OW8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)