UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4CCG98iZtihDJDoKz1YKbJhan7drIFaJv4kUbDdl+v4='
WHERE
key_id = '0807ab255b4b17daa33d62a4ac19f87f93dee16bc33af1f1f3ea1cb6cdebdeaa'
AND (
token = '4CCG98iZtihDJDoKz1YKbJhan7drIFaJv4kUbDdl+v4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)