UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'na+fAYm77hZGtIBAaoph7e0D0cIn/qjmI1HudARV7Sw='
WHERE
key_id = 'b9a7b6c2880197fb22c96643f661c2a5ea1fe7e36a221a2476ece5c7b9ea0674'
AND (
token = 'na+fAYm77hZGtIBAaoph7e0D0cIn/qjmI1HudARV7Sw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)