UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nD4sj9eHvAfUj6IrMQNYluTx1lFLrODVAgV9csS/Dcg='
WHERE
key_id = '4c3d81bfaa35b9821808ea238d6cd63d747bba3884dc19e940af2fdf34b95aaf'
AND (
token = 'nD4sj9eHvAfUj6IrMQNYluTx1lFLrODVAgV9csS/Dcg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)