UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rfn7LNh8AiNM+xe+bBlL4JAkzZj8BE0Hs92TUQ7jCtw='
WHERE
key_id = 'c3822bf0f412acf187985c964b3283bc3ed4635db49bb980f2905ada42de154a'
AND (
token = 'rfn7LNh8AiNM+xe+bBlL4JAkzZj8BE0Hs92TUQ7jCtw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)