UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'fn4qwqixrU0W6o4n7wTfHKlRpz4vKWYgSrmEQOnGPFE=' 
WHERE 
  key_id = 'a2dc5f1994fa7b664ed3fe070ad2e88a5e6a63727c2f4a5bb628cd8c4af38ef2' 
  AND (
    token = 'fn4qwqixrU0W6o4n7wTfHKlRpz4vKWYgSrmEQOnGPFE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027