UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bCAeK+tv5yd47o3EiDpm2eq9PsB7YHTBCt5SfFkPGh8='
WHERE
key_id = 'e4ff9e65f967e08ef0f8f0da145fd3a59fda0cb7f57302bd0f5f48fad53b5c5c'
AND (
token = 'bCAeK+tv5yd47o3EiDpm2eq9PsB7YHTBCt5SfFkPGh8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)