UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'UDCQWjXf2g46G9d2zyANpCyJ3ZMBk36z29toUHA5fdI=' 
WHERE 
  key_id = '06c32a14a4943288adfd416f27946e39e8175907b4da85ae54b6417f0a201bce' 
  AND (
    token = 'UDCQWjXf2g46G9d2zyANpCyJ3ZMBk36z29toUHA5fdI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040