UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'SKPp1ZqSARIpfHMlXSkjEARXrIWdZ3oUnOVpF1gqm+4=' 
WHERE 
  key_id = 'add74821fe1bcb8d52663bcd8eb059c8974b998752a3bc1d8ee39e4ad646f119' 
  AND (
    token = 'SKPp1ZqSARIpfHMlXSkjEARXrIWdZ3oUnOVpF1gqm+4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024