UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g8ikZoKxzeFvau2TLxt41jyGWgSGi7h0HAEKKV45PlA='
WHERE
key_id = 'aeab79ef0e2c8e1674dd71f41d25949bcde934051319b572c30656ca7d33e797'
AND (
token = 'g8ikZoKxzeFvau2TLxt41jyGWgSGi7h0HAEKKV45PlA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)