UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SZDM0MpU5C3W/G2W8ePlX90jy2MTEpPo3rd24F93mt4='
WHERE
key_id = 'bb6de916c29eca33ed774ebadd5cc5c8313aa0301c48d7881a439244b843b8d6'
AND (
token = 'SZDM0MpU5C3W/G2W8ePlX90jy2MTEpPo3rd24F93mt4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)