UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D5cS6nX9BzgRBZaGMAsbgpvVzP9tiO6ffUYmmoL4qBU='
WHERE
key_id = '46a6b5a0872cb0e00ca2ea328f0b6c13146b4082b382efef4567bb192df51793'
AND (
token = 'D5cS6nX9BzgRBZaGMAsbgpvVzP9tiO6ffUYmmoL4qBU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)