UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZfA6TS2wjSeGWpPsqGpSywvJNYoVLSOKZSSSEohn/po='
WHERE
key_id = '9867dff3a9f4df8b5d3db6ab602bfce678bfcb2d44e265e3dcc92f67a549dc05'
AND (
token = 'ZfA6TS2wjSeGWpPsqGpSywvJNYoVLSOKZSSSEohn/po='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)