UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h6TyIgV9A/E7zBp3Lv/lWS8O8M+eaggqoZbeGaifI+A='
WHERE
key_id = 'b697035659e30e9e34fafa0e58555f29e03ea4f7b9c50c3272201129d96a6a14'
AND (
token = 'h6TyIgV9A/E7zBp3Lv/lWS8O8M+eaggqoZbeGaifI+A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)