UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BpNKqVnoB79GRehyRiJKJJlgtClHM9M1yj7gViBqOec='
WHERE
key_id = '77a97c91653a50d33455a24dcce638c2e612d141a963aeccbd50032f1cc0a4a7'
AND (
token = 'BpNKqVnoB79GRehyRiJKJJlgtClHM9M1yj7gViBqOec='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)