UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u9FL6xXzcW3fkKKAV01MnzsHs1N9PhjQOh1tcEllw80='
WHERE
key_id = '8e3636b4baeaae0e3d63a9da22fe5f9340ae65e3d2d4838ea0e80eaad810cad1'
AND (
token = 'u9FL6xXzcW3fkKKAV01MnzsHs1N9PhjQOh1tcEllw80='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)