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