UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XK9/d6PZlSI/kTQCJBk6ByOdSw0s07snjVktV9YhSj8='
WHERE
key_id = '4bacb091a2d56b6f197338635d2b7b8b15acc7e1b4c18543ff9adafaf0896fd6'
AND (
token = 'XK9/d6PZlSI/kTQCJBk6ByOdSw0s07snjVktV9YhSj8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)