UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dgHS9cZPzLF4lpLQTZCKE6USi1bJUxq5PYpCOdvRB90='
WHERE
key_id = 'f8873c1249d651b11beb8a07ac6ce1b87ff21fa7281acdc2542ac346607780d3'
AND (
token = 'dgHS9cZPzLF4lpLQTZCKE6USi1bJUxq5PYpCOdvRB90='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)