UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WTBGVesKWf23EPuwPdXGzmN914PYZjseiqY9HVq1zwY='
WHERE
key_id = '0bc4ba4a336e6df2f4903588d468b04f488b7516f068cc83dacea906e29b8413'
AND (
token = 'WTBGVesKWf23EPuwPdXGzmN914PYZjseiqY9HVq1zwY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)