UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd1oigGm60PVi7ESpXAO7ukKaKma9otwyt6RtQXaNUV8='
WHERE
key_id = '9adedd3bb4a321f737bdd60a94b1c8b336294383d902771144d2ae47c4a5ecb2'
AND (
token = 'd1oigGm60PVi7ESpXAO7ukKaKma9otwyt6RtQXaNUV8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)