UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XXbL5LMF64Qv53H1i8/7e+nqt8cCCNCaufHCXjmwobw='
WHERE
key_id = 'f48f7ab4290de5f1d1be3192fec13012dc72a0f1352b6446dde85c09852cde5f'
AND (
token = 'XXbL5LMF64Qv53H1i8/7e+nqt8cCCNCaufHCXjmwobw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)