UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'qI0BRAexJE7aGTOdX7Y2ejnhId3+D9YMZHeCxPo8ucU=' 
WHERE 
  key_id = 'bc66a49e6f5a68aa9455aede0b43720bed1a8fc9184b40a31b736d77e7dd381c' 
  AND (
    token = 'qI0BRAexJE7aGTOdX7Y2ejnhId3+D9YMZHeCxPo8ucU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022