UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 't8lo4saGCCqJ4TEPnCkp/QDlv19wTQKWrTN3D/vY4xE='
WHERE
key_id = 'd2451eaec48a1a6278ff45f743128441f5841d941467c2da9101f39a952beb0c'
AND (
token = 't8lo4saGCCqJ4TEPnCkp/QDlv19wTQKWrTN3D/vY4xE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)