UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '456IB2QOUvGN8mHdcbDNDO9nKZ2zSHfbZ5gc9Mos7dw=' 
WHERE 
  key_id = '527904e99de987d03053cd793905e52a86169c373e27ea904accd945c85904e7' 
  AND (
    token = '456IB2QOUvGN8mHdcbDNDO9nKZ2zSHfbZ5gc9Mos7dw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00039