UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4P3KTy8cfM/kDvJb9UDc+YOv/EkQ2LTvSEwcuJduIgY='
WHERE
key_id = '27a0c5bb963cf88d15d482791ab7ca419728539dd5565fcd417017db6cc04ecf'
AND (
token = '4P3KTy8cfM/kDvJb9UDc+YOv/EkQ2LTvSEwcuJduIgY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)