UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r9+93uVQU6PsWp3p5Iq0e2lOotzvXG6hSFrxI+U9Tsw='
WHERE
key_id = 'e09712cb2165851cefd3218ad59116b266fe6b0113e768435328b1bcad2b32d2'
AND (
token = 'r9+93uVQU6PsWp3p5Iq0e2lOotzvXG6hSFrxI+U9Tsw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)