UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7qKdrJK8AN4h64sNtugKZ5XTlW4oIcLi5E8lAT39Rng='
WHERE
key_id = 'c3a78b3df35cffd55dc7972975046da6d00a8e1fc79c6800c27fa83ef22a8361'
AND (
token = '7qKdrJK8AN4h64sNtugKZ5XTlW4oIcLi5E8lAT39Rng='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)