UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9DH/wJvhcxcaCxzNjdQquZY9X9yPnpPTkNlK3WiS+G0='
WHERE
key_id = '5adbfd06167118d388489ed680f7b835596f25a2b1ae262cb4a68f5b2b847f6d'
AND (
token = '9DH/wJvhcxcaCxzNjdQquZY9X9yPnpPTkNlK3WiS+G0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)