UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2nfg0U86mpWGt7BesCh8zFbaV89k7V1+HuG2Wmv5QD4='
WHERE
key_id = 'a71f3dce65b9d30e24e360ce818988a94385eb6a962258f3c10f30fc6d0dba8c'
AND (
token = '2nfg0U86mpWGt7BesCh8zFbaV89k7V1+HuG2Wmv5QD4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)